UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yJy9GpVz939ASCXt2JLFvod/0EkScaFRRUJ7K3J7HNY='
WHERE
key_id = 'd44b27691e2123dfac77a9f49a23de2a93dcf0b2a2675913ff426a23d4b89e19'
AND (
token = 'yJy9GpVz939ASCXt2JLFvod/0EkScaFRRUJ7K3J7HNY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)