UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q8pwdyFDQkMBqszr0kGFdifwarhSXtM9hJenMP1naIQ='
WHERE
key_id = '2cc5d6e512922d6620b213a55302a7e5dda0fbd0c22daa7d0cec48237c2ab996'
AND (
token = 'q8pwdyFDQkMBqszr0kGFdifwarhSXtM9hJenMP1naIQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)