UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w73Me5cAW7hzs8uOT7pZRC8wwFvPzxx3stxhlopMbD0='
WHERE
key_id = '9e2817b15f28943dce13168976751cc38ed35f88a03f70afdf7074fac0beb00f'
AND (
token = 'w73Me5cAW7hzs8uOT7pZRC8wwFvPzxx3stxhlopMbD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)