UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sS0xSQOiQGKNB9hsiH4OsfzWD/6n2XVrKwLqwtp1vrE='
WHERE
key_id = 'ef9b56d969ad7f3a6bb020d7b989481251a96cfdae853a6542e2985a04f2d604'
AND (
token = 'sS0xSQOiQGKNB9hsiH4OsfzWD/6n2XVrKwLqwtp1vrE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)