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