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