UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/c/ZM9+cGF8cFPWJcZ+cOp3U+ORZJ//puPOLADFXYfA='
WHERE
key_id = '8236c2ba47e21bb39e2531da09bfd28a11ff5a49004b454df76f793fe66c159c'
AND (
token = '/c/ZM9+cGF8cFPWJcZ+cOp3U+ORZJ//puPOLADFXYfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)