UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Mn4ECnWJZdg/QIWDFtPj8wlEewewENvDxekM2VbO4Ys='
WHERE
key_id = '192c20bfcba377b3902517875c6917e62297fe1a9e87011e6eab5ac7734f5b06'
AND (
token = 'Mn4ECnWJZdg/QIWDFtPj8wlEewewENvDxekM2VbO4Ys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)