UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a775lis5qmqvUGpFO5qBnIggcWCEt+A019H5IhdePwU='
WHERE
key_id = '8d01a3074441bd30ad5504921c31413146d2204b4939982c9e5d8302cd7debb1'
AND (
token = 'a775lis5qmqvUGpFO5qBnIggcWCEt+A019H5IhdePwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)