UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gtmu1KA0ptxcE4eWOkkkZNZ03r/kQGKihQvbhNVTpdA='
WHERE
key_id = '8308969dfa70f8a9976b78340b36b12331175c0c7107f5e128f0b3d30dbd5808'
AND (
token = 'gtmu1KA0ptxcE4eWOkkkZNZ03r/kQGKihQvbhNVTpdA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)