UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gPjPBCU4wHj5KURcaIztVtJONnt3ZyB0cRIXWkZHllY='
WHERE
key_id = 'a25b736e7e4548a6ce273e6ea11862c8c9888132313aa49c0a0d2538fc2d049d'
AND (
token = 'gPjPBCU4wHj5KURcaIztVtJONnt3ZyB0cRIXWkZHllY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)