UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HB7ArF0BaOeftt7tS4tiU62SlBM8L6mjTqZen8Lcl84='
WHERE
key_id = '1c110f329c26b7caf1a035f273c7fa88031aae91cea62437cba1eddb300718ed'
AND (
token = 'HB7ArF0BaOeftt7tS4tiU62SlBM8L6mjTqZen8Lcl84='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)