UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W9XjL35JNu69xOAVVfvb3AV8qcM1inriKBXgzlCIBCk='
WHERE
key_id = 'f67bd4bfbbaf9c15f3d12ced20979acf37f07076642fbc02af412f1da74d3016'
AND (
token = 'W9XjL35JNu69xOAVVfvb3AV8qcM1inriKBXgzlCIBCk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)