UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l8SOzae5BD0lmokQPKsQUSVj8Ra9ibWn5xUviQ2bv4U='
WHERE
key_id = 'f24d02f5552e3e37d3e63f59469b5d826ef2159253201b89d93f6c9307842ec7'
AND (
token = 'l8SOzae5BD0lmokQPKsQUSVj8Ra9ibWn5xUviQ2bv4U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)