UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9IOwEWT92Yv9pKd3BRqFbUip32pVRt8Idkz0AjDnqWo='
WHERE
key_id = 'abed69b2b36358ec5ddca755a1013a91897abe049f4a6fe7690b57f99f754451'
AND (
token = '9IOwEWT92Yv9pKd3BRqFbUip32pVRt8Idkz0AjDnqWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)