UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lr000/ZHn69ReB4QNufcqSl7g61nTV7EWPXNeP+UvYc='
WHERE
key_id = '6587325db7d2bd15b8c7e53195ec1cc938a1342a076394ddae4396bb92cc8bfc'
AND (
token = 'lr000/ZHn69ReB4QNufcqSl7g61nTV7EWPXNeP+UvYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)