UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BWgLtjiV4dZxmvCyakXv9MYIP/uPVq/yDovB4j1Uh90='
WHERE
key_id = '1dad0866fe7ad6ea491283b084f29ca704b32620e00b5b13f6141ed1c1415470'
AND (
token = 'BWgLtjiV4dZxmvCyakXv9MYIP/uPVq/yDovB4j1Uh90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)