UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k5YxZiBmQccxtLOMNwB/1gmbPctu2wmoxIkj8zSWgK0='
WHERE
key_id = 'ba8aa6c6b0e891af6a26871cd1adc72e40cdb6fe27320a3435bb75ed122a7bf4'
AND (
token = 'k5YxZiBmQccxtLOMNwB/1gmbPctu2wmoxIkj8zSWgK0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)