UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '54WwxGw0ItRTxOnqaFg/WQM0Nd3rg0MijRjvTyhJUgk='
WHERE
key_id = '9f27ba975188655a8459e99e641c0cde551849ab427f7fc249817a65dc5fa6df'
AND (
token = '54WwxGw0ItRTxOnqaFg/WQM0Nd3rg0MijRjvTyhJUgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)