UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HbA6QtBQK5D6RTjWU7UAc05GRZMsGQbTxONTnNoajWM='
WHERE
key_id = '5c00e37e846152222c4708d2b67bb32e8ebf2e777cb1c234a58e36ad0fcc2e8e'
AND (
token = 'HbA6QtBQK5D6RTjWU7UAc05GRZMsGQbTxONTnNoajWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)