UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xnrwf+4gsgY0hRXO+EPC1PY4UqMPChA5Jp0uitDfZFQ='
WHERE
key_id = '1c6422957184461c6ab1ad66bda7e6ac37c3122fc45031fffa2606dbfc34da12'
AND (
token = 'Xnrwf+4gsgY0hRXO+EPC1PY4UqMPChA5Jp0uitDfZFQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)