UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J3thktKsFANPZ+glEPtbybiCUbINM4Zy8NrMY04tA/Q='
WHERE
key_id = 'e8caa929c36e78437b22931c1e106fabc853e3bb1cd9f512bd7aebf41e9f1cb1'
AND (
token = 'J3thktKsFANPZ+glEPtbybiCUbINM4Zy8NrMY04tA/Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)