UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tc2PSWX1NbHW52My1r99mZFChPIBOdCnvvsRJqi5i9Q='
WHERE
key_id = 'ca06bc9a04e1fa9b447d1f4ec5065dcd530e590734fa7e504d1504d96fa8c9d7'
AND (
token = 'Tc2PSWX1NbHW52My1r99mZFChPIBOdCnvvsRJqi5i9Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)