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