UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8jHSBuUrJhMptNI3TXVNjFaizd/9Y2KRW/an5m6sDPc='
WHERE
key_id = '29a5f8ad2a155b5ae42ca2431dd1c088dbdbe565182f4890a2456d768632a79e'
AND (
token = '8jHSBuUrJhMptNI3TXVNjFaizd/9Y2KRW/an5m6sDPc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)