UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X99FnDgntBk0i1vK5gI4oYCyMoTgBsed5+TfJIPIr5o='
WHERE
key_id = 'c59153bc153fa48020ee4f62894ea40fbf6aefc91468c4eee493c78a4437c626'
AND (
token = 'X99FnDgntBk0i1vK5gI4oYCyMoTgBsed5+TfJIPIr5o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)