UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3WptQfJHFSd2hpeir/tmDHRi9CelViaFN6momEHSSl0='
WHERE
key_id = 'ff1dcb499887b10f2cd0dafca38c27e0ddd9cd99721bcc6c09584d674b0ec610'
AND (
token = '3WptQfJHFSd2hpeir/tmDHRi9CelViaFN6momEHSSl0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)