UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8SbCbbhOfSdVvzoqm6MMwW6HadWwk9X8R5P8Ognu1PU='
WHERE
key_id = '6592b53ca5d1b4e79356fa7ccc5bb33f2ea1b5d4cea5195d46188ec5fa327bf0'
AND (
token = '8SbCbbhOfSdVvzoqm6MMwW6HadWwk9X8R5P8Ognu1PU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)