UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N/lQadd+f60x3H99LkiBLvdbufSdsZTGc2Ga6R+NVz8='
WHERE
key_id = 'a467e67a3e336c3d9e2e69fcc4d602fa82b5ad9f7753f37c6bca546eaf5d568b'
AND (
token = 'N/lQadd+f60x3H99LkiBLvdbufSdsZTGc2Ga6R+NVz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)