UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9clvOqBb36bOGz2ifq13ycTXMj4CCMiViv6Z7lf6a+s='
WHERE
key_id = '0ff99873489fcc3fa83a49c9621781615f16a701af44e87cf6bb38144a534c97'
AND (
token = '9clvOqBb36bOGz2ifq13ycTXMj4CCMiViv6Z7lf6a+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)