UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vG7WjAZjaXAdzMgjrnTkiN0CF/O+F9ZaWPH81KSQmbM='
WHERE
key_id = 'd8c9432f8881f60c929536865e1c8b1642b3f90cadc1d5c4d53eb921fbe00c41'
AND (
token = 'vG7WjAZjaXAdzMgjrnTkiN0CF/O+F9ZaWPH81KSQmbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)