UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7rNfrcGHl/ZABeBAhO1rCyVyPemQnMu1wwJ2GEUbvPI='
WHERE
key_id = '7e51b2cfebeda826fc51d50940800f30df1acf236cfa0007fc839a497f7ce967'
AND (
token = '7rNfrcGHl/ZABeBAhO1rCyVyPemQnMu1wwJ2GEUbvPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)