UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bPZtZZqG2WTDhG6hbs9fyvgZWf7t4X/Osip5MO5VHFs='
WHERE
key_id = '101806c1760110bd85b3d3686d345ad644961257ac2d6750ee3ae3b53c2015ee'
AND (
token = 'bPZtZZqG2WTDhG6hbs9fyvgZWf7t4X/Osip5MO5VHFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)