UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tEVXQknVns1hmHop2ZmFAdhkFTIhutElUa8PtN0XZXU='
WHERE
key_id = '5dafbdd7a2701eed3fc6d10f587cdfd5cf594a54886b5b0e87686c6364e6d43e'
AND (
token = 'tEVXQknVns1hmHop2ZmFAdhkFTIhutElUa8PtN0XZXU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)