UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nHsaHYrS3yOF42Gsl4o7rsFIb84cdeqUL1VSMJbPJMs='
WHERE
key_id = '0c9b3168df7319ae58a7a0e8aa9e8f3f38f26665aaf78442e2017adb3929bd83'
AND (
token = 'nHsaHYrS3yOF42Gsl4o7rsFIb84cdeqUL1VSMJbPJMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)