UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UUcpseFkPn+3ocaQ6hCcdQGaMxJWzjMc/0892RZ2JIE='
WHERE
key_id = '813829d86845004b95edf38ffb31a6a92abc387ff2f22116a788a4c5160d0306'
AND (
token = 'UUcpseFkPn+3ocaQ6hCcdQGaMxJWzjMc/0892RZ2JIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)