UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bo9cfjLfHBnFoKuoUfVdbUG5CV3H1qfiqoxSMpjpeXM='
WHERE
key_id = '77ca94ad62dd8dc494e3370d85bdcf8fb669f6815f8c9001814053c52bb6385f'
AND (
token = 'bo9cfjLfHBnFoKuoUfVdbUG5CV3H1qfiqoxSMpjpeXM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)