UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OMFoXKfZPNw9P9bGBRT2muzMwmH0BQFRFpQJ7o8oMk8='
WHERE
key_id = '2a1ee431fc0f049c0b5768007c88ef197b03ca2a5bf5930e3aa48f83eb66a6ec'
AND (
token = 'OMFoXKfZPNw9P9bGBRT2muzMwmH0BQFRFpQJ7o8oMk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)